Skip to content
  • 0 Votes
    3 Posts
    228 Views
    zaasmiZ

    Graphics library for 64 bit Dev CPP.rar

  • 0 Votes
    5 Posts
    245 Views
    zaasmiZ

    @Faaizaa said in CS614 Assignment 2 Solution and Discussion Spring 2020:

    Re: CS614 Assignment 2 Solution and Discussion

    Assignment No. 2
    Semester: Spring 2020
    CS614 – Data Warehousing
    Total Marks: 15

    Due Date:
    June 17, 2020

    Objectives:
    After completing this assignment, the students will be able to:
    • De-Normalize the given table using horizontal splitting technique
    • Calculate the Total space used with normalization.
    • Calculate the Total space used after de-normalization.

    Instructions
    Please read the following instructions carefully before submitting assignment:
    It should be clear that your assignment will not get any credit if:

    • Assignment is submitted after due date.
    • Submitted assignment does not open or file is corrupt.
    • Assignment is copied (From internet/ to from students).
    • Assignment is submitted other than word format (.doc, .docx).

    Assignment

    Question No. 1

    Consider the following table having the information of students of a university:

    Student ID Student Name Campus ID Student Age Degree Program 1 Ali VLHR01 27 MS 2 Kamran VISB01 24 BS 3 Akmal VRWP01 24 BS 4 Ahmad VLHR01 26 MS 5 Rehan VISB01 23 BS 6 Rizwan VRWP01 29 MS 7 Umer VISB01 25 BS 8 Javed VLHR01 26 MS

    You are required to completely de-normalize the above table using “horizontal splitting” on the basis of Degree Program.

    Question No. 2
    Consider the following normalized tables for a telecommunication company showing the daily call record details of customers:

    Customer Info Customer_ID Customer Phone No. Balance 1 033XXXXX 300 2 033YYYYY 250 3 033ZZZZZZ 300 4 033AAAAA 1000 5 033BBBBB 80 6 033CCCCC 554


    … …

    Call record detail Call_ID Customer_ID Dialled Phone Number Duration Call Charges 1 1 032ABCVD 1 minute 2 RS 2 1 032ABCVG 2 minutes 4 RS 3 1 032ABCVD 1 minute 2 RS 4 2 032ANNNN 3 minutes 6 RS 5 2 032AMMM 4 minutes 8 RS 6 3 033RRRRR 1 minute 2 RS

    … … … … …

    Due to certain performance factors company wants to de-normalize the tables using pre-joining technique.

    Table Information is given below:

    • Assume 1:4 record count ratio between customer Info (master) and Call record detail (detail).
    • Assume 15 million customers.
    • Assume 10 byte Customer_ID.
    • Assume 50 byte header for customer Info (master) and 80 byte header for Call record detail (detail) tables.
    You are required to perform the following tasks:

    • Calculate the Total space in GBs used with normalization.
    • Calculate the Total space in GBs used after de-normalization.

    Deadline:
    Your assignment must be uploaded on VULMS on or before June 17, 2020. While June 18, 2020 will be a bonus day for assignment submission. After the bonus day, no assignment would be entertained via email.

    Solution file link

  • 0 Votes
    1 Posts
    74 Views
    No one has replied
  • 0 Votes
    1 Posts
    90 Views
    No one has replied
  • 0 Votes
    2 Posts
    441 Views
    zaasmiZ

    11bf63b2-4d58-4470-bda8-51c1f310223e-image.png dab411a1-d5e6-4659-9246-4db1fb98ac14-image.png 0ba639b3-6c8c-4dbc-8d14-9d91a17e1f73-image.png e0d4f9ce-f6d1-4fee-ad85-fa9acaf07bb7-image.png 11cabe36-55d7-4de3-834d-e597b298ae75-image.png e999b982-4d2b-4ff8-80aa-4ca7e970da20-image.png 45bb2cdb-cae1-4a24-8cdb-1c3552d8e24b-image.png

  • 0 Votes
    3 Posts
    313 Views
    zaasmiZ

    @zaasmi said in CS408 Assignment 2 Solution and Discussion Spring 2020:

    Question No. 2 05 Marks
    Following table consists some scenarios related to Design principles. You are required to write down the design principle related to the particular scenario.

    S.No.
    Scenario Design
    Principle

    In older version of a work processor, one problem often encounters, when needed to set the properties of a word document, the option of properties should be in the File menu, and often seen it there. But once, file menu opened, it could not show there, it was so confusing. However, when a click on a small arrow at the bottom of file menu, it shows properties option again.

    In a website or any app. graphical elements like button, icon, links, and scroll bars are talked about obvious use like as icons should be designed to clicking, scroll bars to moving up and down, buttons to pushing.

    A common design practice in graphical user interfaces is to deactivate certain menu options by shading them, thereby restricting the user to only actions permissible at that stage of the activity.

    On a computer keyboard, the up and down arrows used to represent the up and down movement of the cursor, respectively.

    In a graphical user interface, the same input action always done to highlight any graphical object at the interfaces, such as always clicking the left mouse button to select the icons.

    5be67f1d-c397-4ded-83de-d61affefc5a2-image.png c227de35-3164-42a3-b82c-f164f3bd1e02-image.png

  • 0 Votes
    3 Posts
    163 Views
    zaasmiZ

    main.adb

    with Ada.Text_IO; use Ada.Text_IO; with Ada.Integer_Text_IO; use Ada.Integer_Text_IO; with Ada.Float_Text_IO; use Ada.Float_Text_IO; with per; use per; with Mn; use Mn; procedure main is -- Creating object of type Men men1 : Men; len: Natural; Begin -- Taking input ID Put_Line("Enter ID : "); Get_Line(men1.ID, len); -- Taking input Name Put_Line("Enter Name : "); Get_Line(men1.Name, len); -- Taking input Gender Put_Line("Enter Gender : "); Get_Line(men1.Gender, len); -- Taking input Height Put_Line("Enter Height : "); Get(men1.Height); -- Taking input Age Put_Line("Enter Age : "); Get(men1.Age); new_line(2); -- Print Function calling print(men1); new_line(3); end main;

    per.ads

    package Per is type Person is tagged record Name: String(1..30):= " "; Age: Integer :=0; Gender: String(1..10) := " "; end record; procedure print(Self : in out Person); end Per;

    main.adb

    with Ada.Text_IO; use Ada.Text_IO; with Ada.Integer_Text_IO; use Ada.Integer_Text_IO; with Ada.Float_Text_IO; use Ada.Float_Text_IO; package body Per is procedure print(Self : in out Person) is begin Put_Line("Name is " & Self.Name); Put_Line("Age is " & Integer'Image (Self.Age)); Put_Line("Gender is " & Self.Gender); end print; end Per;

    mn.ads

    with per; use per; package Mn is type Men is new Person with record Height: Float := 0.0; ID: String(1..15) := " "; end record; overriding procedure print(Self : in out Men); end Mn;

    mn.adb

    with Ada.Text_IO; use Ada.Text_IO; with Ada.Integer_Text_IO; use Ada.Integer_Text_IO; with Ada.Float_Text_IO; use Ada.Float_Text_IO; with per; use per; package body Mn is procedure print(Self : in out Men) is begin Put_Line("ID is " & Self.ID); Put_Line("Name is " & Self.Name); Put_Line("Age is " & Integer'Image (Self.Age)); Put_Line("Gender is " & Self.Gender); Put_Line("Height is " & Float'Image (Self.Height)); end print; end Mn;
  • 0 Votes
    1 Posts
    113 Views
    No one has replied
  • 0 Votes
    5 Posts
    226 Views
    cyberianC

    @zaasmi said in CS604 Assignment 2 Solution and Discussion Spring 2020:

    Re: CS604 Assignment 2 Solution and Discussion

    Operating Systems (CS604)
    Assignment # 02
    Spring 2020
    Total marks = 15

    Deadline Date
    14th June 2020

    Please carefully read the following instructions before attempting assignment.

    RULES FOR MARKING
    It should be clear that your assignment would not get any credit if:
     The assignment is submitted after the due date.
     The submitted assignment does not open or file is corrupt.
     Strict action will be taken if submitted solution is copied from any other student or from the internet.

    You should consult the recommended books to clarify your concepts as handouts are not sufficient.

    You are supposed to submit your assignment in .doc or docx format.
    Any other formats like scan images, PDF, zip, rar, ppt and bmp etc will not be accepted.

    Objective:
    • The objective of this assignment is to learn scheduling algorithm.
    • To learn and understand different Operating System structure.

    NOTE

    No assignment will be accepted after the due date via email in any case (whether it is the case of load shedding or internet malfunctioning etc.). Hence refrain from uploading assignment in the last hour of deadline. It is recommended to upload solution file at least two days before its closing date.

    If you find any mistake or confusion in assignment (Question statement), please consult with your instructor before the deadline. After the deadline no queries will be entertained in this regard.

    For any query, feel free to email at:
    [email protected]

    Question No 01 15 marks
    Consider the following set of processes, with the CPU burst time given in milliseconds:

    Process Burst Time
    P1 10
    P2 1
    P3 2
    P4 1
    P5 5

    The processes are arrived in the order P1, P2, P3, P4, P5, all at time 0.

    A. Draw Gantt chart showing the execution of these processes using FCFS and SJF scheduling.
    B. Calculate the turnaround time of each process for FCFS scheduling algorithm as per part Calculation of part A?
    C. Calculate the waiting time of each process for SJF scheduling algorithm as per calculation of Part A?

    Wish you very Best of Luck!

    CS604_2_Sol_S20_cyberian.pk_.docx

  • 0 Votes
    2 Posts
    153 Views
    zaasmiZ

    CS001 VU-Computer Proficiency License Assignment 2 Solution & Discussion Spring 2020

    CS001 Assignment 2 Solution idea:

    Computer Proficiency License

    (CS001)

    Assignment # 02

    Total marks = 15 Deadline Date 15th June 2020

    Question No 01 7 marks

    Suppose you are working as an IT manager in an IT and electronics company; you are required to write a commercial sales letter to one of your customers (Letter format has been well explained through a template/figure below) using Microsoft Word.

    Consider the following requirements while writing the letter:

    Insert the system date at the specified location.
    Insert a permission request for your team for the installation of the network and UPS.
    Insert a table stating the customer’s complete order details.

    Solution:

    Dear Sir,

    Wednesday,June 10,2020

    Thank you for your electronics goods order

    Sr. No Description Unit Price Quantity Total Price 1 Hp Laptop i7 70,000 10 700,000 2 APCSmart-UPS 1500VA 2U Rack Mount 18,000 2 36,000 Total 736,000

    The two person team bearer of this letter is deputed to attend the installattion and networking, work at your premises, kindly extent them necessary and oblige.

    Your faithfully,

    Name VU ID

    IT Manager, XYZ electronics, Rawalpindi.

    Question No 02 8 marks

    Write the keyboard shortcut keys for the following actions in Microsoft Word:

    Solution:

    Sr. No Action Shortcut key 1 Search a document Ctrl+F 2 Justify a paragraph Ctrl+J 3 Decrease font size Ctrl+[ 4 Bulleted list Ctrl+Shift+L 5 Open the Font dialog box Ctrl+Shift+F 6 Increase font size Ctrl+] 7 Switch to the next window Alt+Tab 8 Insert a copyright symbol Ctrl+Alt+C
  • 0 Votes
    1 Posts
    118 Views
    No one has replied
  • 0 Votes
    2 Posts
    189 Views
    zaasmiZ

  • 0 Votes
    1 Posts
    108 Views
    No one has replied
  • 0 Votes
    2 Posts
    196 Views
    Heer NaqviH

    Plz send Cs507 assignment 2

  • 0 Votes
    1 Posts
    213 Views
    No one has replied
  • 0 Votes
    9 Posts
    4k Views
    zaasmiZ

    Cs403 Assignment 2 Solution.docx